Mandatory fields for the Inventory master file:
|
Field |
Variable required |
What the field represents |
|
ITM_NEWITEM |
1 |
New Item Flag |
|
ITM_PPC |
1 |
Packs Per Carton |
|
ITM_STAX |
1 |
Items Sales Tax Table Number |
|
ITM_STAXPERCENT |
To the Percentage |
Item Actual Sales Tax Percentage |
|
ITM_DUTYRATE |
1 |
Default Item Duty Table Rate |
|
ITM_PUNIT |
1 |
Purchase Units |
|
ITM_FIFOON |
2 |
Item FIFO Flag Off |
|
ITM_SUNIT |
1 |
Item Sales Units |
Mandatory fields for the Debtors master file:
|
Field |
Variable required |
What the field represents |
|
DBT_TERMS |
30 |
Debtors Trading Terms |
|
DBT_ITERMS |
30 |
Debtor Invoice Terms |
|
DBT_TAXNo |
TAXABLE |
Debtor Tax Number, EXEMPT or TAXABLE |
|
DBT_RETAIL |
'W' |
Debtors Retail/Wholesale Flag |
|
DBT_ALLOWBO |
1 |
1=Allow Backorders, 0=No Backorders |
|
DBT_BALTYPE |
'O' |
Debtor Balance Type O=Open Item |